﻿create table [dbo].[Process]
(
	[ProcessId]                         int                 not null        identity(1, 1)
	, [ConcurrencyId]					rowversion			not null
	, [BasePriority]					int					not null
	, [ExitCode]						int					null
	, [ExitTime]						datetime2			null
	, [HasExited]						bit					not null
	, [HandleCount]                     int                 not null
	, [Id]								int					not null
	, [MachineName]                     nvarchar(100)       not null
	, [MainModule]                      nvarchar(512)       not null
	, [MainWindowTitle]                 nvarchar(100)       null
	, [MaxWorkingSet]                   bigint              not null
	, [MinWorkingSet]                   bigint              not null
	, [NonpagedSystemMemorySize64]		bigint				not null
	, [PagedMemorySize64]				bigint				not null
	, [PagedSystemMemorySize64]			bigint				not null
	, [PeakPagedMemorySize64]			bigint				not null
	, [PeakVirtualMemorySize64]			bigint				not null
	, [PeakWorkingSet64]				bigint				not null
	, [PriorityBoostEnabled]			bit					not null
	, [PriorityClass]                   nvarchar(100)       not null
	, [PrivateMemorySize64]				bigint				not null
	, [PrivilegedProcessorTime]			time         	    not null
	, [ProcessName]						nvarchar(100)		not null
	, [ProcessorAffinity]				bigint				not null
	, [Responding]						bit					not null
	, [SessionId]						int					not null
	, [StartTime]						datetime2			not null
	, [Threads]							int					not null
	, [TotalProcessorTime]				time         	    not null
	, [UserProcessorTime]				time         	    not null
	, [VirtualMemorySize64]				bigint				not null
	, [WorkingSet64]					bigint				not null
	, [Created]                         datetime2           not null
	, [Updated]                         datetime2           not null
)